| Block Group: | Table Operations |
| Icon: |
|
The JSON Parser block converts a JSON string into a table. The output table can contain other tables.
This is a commonly used block, because many data-driven features in Solution Builder, such as charts and repeaters, require tabular data.
The JSON Parser block is sometimes used to parse a string that has been loaded by a String Loader block.
The following properties of the JSON Parser block can take input and give output.
input receives the JSON string. Sometimes it is the output from a String Loader block.
selector specifies the location of the data in the JSON string to parse into a table.
drillDownDepth specifies how far to drill down into the JSON when extracting data. Data below the drillDownDepth is not included in the output. The drillDownDepth property works only when a drillDownFilter or flatFilter is specified.
drillDownFilter specifies what to return for nested tables. Enter * to return all nested tables to the specified drillDownDepth.
flatFilter specifies what to return for a flat table. Enter * to return all data to the specified drillDownDepth, in a flat table.
The following properties of the JSON Parser block can give output but cannot take input.
output returns a table parsed from the JSON data.
parseError indicates whether the block encountered an error. An error might be caused by improperly formatted input.
The following image shows, clockwise from top left:
